home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / mrreconcile.sql < prev    next >
Text File  |  2000-05-12  |  1KB  |  38 lines
  1. /* RCSVER $Id: mrreconcile.sql,v 1.2 2000-02-18 16:19:58-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:         mrreconcile
  6. * Date:         09/01/1999
  7. * memo:         Randy Wood
  8. * Description:  Create the mrreconcile view. This view contains data from
  9. *               moneyroom counts with and without adjustments.
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE OR REPLACE VIEW mrreconcile AS SELECT 
  13. mrpend.subbatch_seq,
  14. mrpend.prpend_indx,
  15. subbatch.coin_one pennies, 
  16. subbatch.coin_two nickels, 
  17. subbatch.coin_three dimes, 
  18. subbatch.coin_four quarters,
  19. subbatch.coin_five half_dollars, 
  20. subbatch.coin_six dollar_coin, 
  21. subbatch.coin_total_value,
  22. subbatch.bill_one ones, 
  23. subbatch.bill_two fives, 
  24. subbatch.bill_three tens, 
  25. subbatch.bill_four twenties, 
  26. subbatch.receipt_total bill_total,
  27. subbatch.grand_total,
  28. subbatch.label_c orig_cashbox_glid,
  29. cashboxtotals.count_date,
  30. cashboxtotals.cashbox_glid,
  31. cashboxtotals.coin_total adj_coin_total,
  32. cashboxtotals.bill_total adj_bill_total,
  33. cashboxtotals.grand_total adj_grand_total
  34. FROM mrpend, subbatch, cashboxtotals
  35. WHERE
  36. subbatch.subbatch_seq = mrpend.subbatch_seq AND
  37. cashboxtotals.cashbox_total_seq = mrpend.subbatch_seq;
  38.